backuplogtodisk'nul'

2023年12月28日—NUL磁碟裝置將捨棄傳送給它的所有資訊，而且只應用於測試。這不適用於生產環境。重要.從SQLServer2012(11.x)SP1CU2開始到SQLServer2014 ...,2017年7月31日—Youcanusethiscommand:BACKUPLogsandbox2TODISK=N'nul'.Thiswillrunabackup,anddiscardallofthebackupdata.,2017年6月5日—NULisbasicallyalocationyoucansendabackupto.Infact,oneoftheawesomebonusesofthislocationisthatyourbackupwilltakeupexactly0by...

參考資訊如下
BACKUP (Transact-SQL)

2023年12月28日 — NUL 磁碟裝置將捨棄傳送給它的所有資訊，而且只應用於測試。 這不適用於生產環境。 重要. 從SQL Server 2012 (11.x) SP1 CU2 開始到SQL Server 2014 ...

Backup Log to Nul

2017年7月31日 — You can use this command: BACKUP Log sandbox2 TO DISK = N'nul'. This will run a backup, and discard all of the backup data.

Backup to NUL

2017年6月5日 — NUL is basically a location you can send a backup to. In fact, one of the awesome bonuses of this location is that your backup will take up exactly 0 bytes of ...

How to BACKUP LOG WITH TRUNCATE_ONLY in SQL ...

BACKUP LOG WITH TRUNCATE_ONLY is a dangerous command: it empties out the contents of your SQL Server's transaction log without really backing it up.

SQL SERVER

2015年10月26日 — The trick here is to take backup on NUL device. It's not a typo and there is no missing L in NUL. It is called as “NULL Device”.

Taking backup with option "Disk = nul"

2010年7月26日 — BACKUP DATABASE DB_PROD TO DISK = N'nul' ... However all log backups past that point are totally useless because of the missing log backup file.

Understanding Backup to NUL

2024年1月2日 — In SQL Server, backing up to NUL is akin to sending your data into a black hole. The command essentially directs the backup stream to a dummy device.

[SQL Server]：謹慎使用BACKUP DATABASE TO DISK = 'NUL'

2017年6月3日 — NUL是虛擬的空設備，寫入到NUL設備的資料將被丟棄。這是在DOS 作業系統(Disk Operating System)時就已經有的指令，在Windows 作業系統同樣可以使用。 用於 ...